{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["NUMBERS REQUIRED","SEARCH A","SEARCH B","RandomSearchA","RandomSearchB"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"NUMBERS REQUIRED","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[5,4,7,4],[0,1,0,3]]}
[null,"IMMUNE DEFENCE STUDY:  RANDOM PATIENT SELECTION "]
[null,"To allow for GP exclusions, we need approximately",1100,"patients from the 3 searches -"]
[]
[null,"Type in the number of patients found by SEARCH P:",0,null,"We will write to all of these patients"]
[]
[null,"Number of patients you have pasted into SEARCH A:",{"$f":"COUNT('SEARCH A'!A:A)","v":0},{"$f":"IFERROR(SUM(C6)/C9,\"\")","v":""},"We will break down the remainder of the 1100 invitations into these proportions"]
[null,null,null,">"]
[null,"Number of patients you have pasted into SEARCH B:",{"$f":"COUNT('SEARCH B'!A:A)","v":0},{"$f":"IFERROR(SUM(C8)/C9,\"\")","v":""}]
[null,null,{"$f":"SUM(C6)+C8","v":0}]
[null,null,{"$f":"SUM(C2)-(C4)","v":1100}]
[null,"Now press this button to randomly select ",{"$f":"IFERROR(SUM(C10)*D6,0)","v":0},"patients from SEARCH A >"]
[]
[null,"and press this button to randomly select",{"$f":"IFERROR(SUM(C10)*D8,0)","v":0},"patients from SEARCH B >"]

{"sheet":"SEARCH A","index":1,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["PASTE THE PATIENTS FOUND BY SEARCH A (RISK FACTORS) INTO THE WHITE ROWS BELOW:"]
["Record No","Title","FirstName","FamilyName","Address1","Address2","Address3","Address4","Postcode","GPName"]

{"sheet":"SEARCH B","index":2,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["PASTE THE PATIENTS FOUND BY SEARCH B (AGED 65+) HERE:",null,null,null," INTO THE WHITE ROWS BELOW"]
["Record No","Title","FirstName","FamilyName","Address1","Address2","Address3","Address4","Postcode","GPName"]

{"sheet":"RandomSearchA","index":3,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["HERE ARE YOUR RANDOMLY SELECTED PATIENTS FROM SEARCH A (Patients with Risk Factors)"]
["Record No","Title","FirstName","FamilyName","Address1","Address2","Address3","Address4","Postcode","GPName"]

{"sheet":"RandomSearchB","index":4,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["HERE ARE YOUR RANDOMLY SELECTED PATIENTS FROM SEARCH B (Patients aged 65+)"]
["Record No","Title","FirstName","FamilyName","Address1","Address2","Address3","Address4","Postcode","GPName"]